
--1 基础参数

CREATE TABLE BASE_PARAM
(
  ID           NUMBER(10)                       NOT NULL,
  NAME         NVARCHAR2(50)                    NOT NULL,
  POS          NUMBER(10)                       NOT NULL,
  CATEGORY     NVARCHAR2(50)                    NOT NULL,
  SERVERFILE   NVARCHAR2(200),
  FILEEXT      NVARCHAR2(100),
  FILESIZE     NUMBER(10),
  STATUS       NUMBER(10),
  CREATE_ID    NUMBER(10),
  CREATE_TIME  DATE,
  UPDATE_ID    NUMBER(10),
  UPDATE_TIME  DATE,
  DESCN        NVARCHAR2(255)
);

ALTER TABLE BASE_PARAM ADD (
  PRIMARY KEY
 (ID)
    USING INDEX);


--2 参数类型

CREATE TABLE INSPECT_TYPE
(
  ID           INTEGER                          NOT NULL,
  NAME         VARCHAR2(50 BYTE)                NOT NULL,
  POS          INTEGER                          NOT NULL,
  STATUS       INTEGER,
  CREATE_ID    INTEGER,
  CREATE_TIME  DATE,
  UPDATE_ID    INTEGER,
  UPDATE_TIME  DATE,
  DESCN        NVARCHAR2(200)
);


ALTER TABLE INSPECT_TYPE ADD (
  PRIMARY KEY
 (ID)
    USING INDEX);


--3 督办观察员

CREATE TABLE INSPECT_OBSERVER
(
  ID           NUMBER(10)                       NOT NULL,
  CREATE_ID    NUMBER(10),
  CREATE_TIME  DATE,
  UPDATE_ID    NUMBER(10),
  UPDATE_TIME  DATE,
  USER_ID      NUMBER(10)
);

ALTER TABLE INSPECT_OBSERVER ADD (
  PRIMARY KEY
 (ID)
    USING INDEX);


ALTER TABLE INSPECT_OBSERVER ADD (
  CONSTRAINT FK5A0B38A1E56636FD 
 FOREIGN KEY (USER_ID) 
 REFERENCES SYSTEM_USERS (ID));


--4 督办观察员有权查看的部门

CREATE TABLE INSPECT_OBSERVER_DEPT
(
  ID                   NUMBER(10)               NOT NULL,
  DEPT_ID              NUMBER(10),
  INSPECT_OBSERVER_ID  NUMBER(10)               NOT NULL,
  INSPECTOBSERVER_ID   NUMBER(10)
);



ALTER TABLE INSPECT_OBSERVER_DEPT ADD (
  PRIMARY KEY
 (ID)
    USING INDEX 
   );


ALTER TABLE INSPECT_OBSERVER_DEPT ADD (
  CONSTRAINT FKDC5DBB233C8CB251 
 FOREIGN KEY (INSPECT_OBSERVER_ID) 
 REFERENCES INSPECT_OBSERVER (ID));

ALTER TABLE INSPECT_OBSERVER_DEPT ADD (
  CONSTRAINT FKDC5DBB234ACC6CBD 
 FOREIGN KEY (DEPT_ID) 
 REFERENCES SYSTEM_DEPTS (ID));

ALTER TABLE INSPECT_OBSERVER_DEPT ADD (
  CONSTRAINT FKDC5DBB23873DB968 
 FOREIGN KEY (INSPECTOBSERVER_ID) 
 REFERENCES INSPECT_OBSERVER (ID));


--5 督办编号设置

CREATE TABLE INSPECT_SN_SET
(
  ID           NUMBER(10)                       NOT NULL,
  CREATE_ID    NUMBER(10),
  CREATE_TIME  DATE,
  UPDATE_ID    NUMBER(10),
  UPDATE_TIME  DATE,
  SN_RULE      NVARCHAR2(1),
  CONDITION    NVARCHAR2(60),
  FORMAT       NVARCHAR2(100),
  BEGIN_NO     NUMBER(10),
  DIGIT        NVARCHAR2(10),
  CAN_BREAK    NUMBER(10),
  START_DATE   DATE,
  END_DATE     DATE
);

ALTER TABLE INSPECT_SN_SET ADD (
  PRIMARY KEY
 (ID)
    USING INDEX);


--6 断号记录

CREATE TABLE INSPECT_SN_REMAIN
(
  ID               NUMBER(10)                   NOT NULL,
  CREATE_ID        NUMBER(10),
  CREATE_TIME      DATE,
  UPDATE_ID        NUMBER(10),
  UPDATE_TIME      DATE,
  INSPECT_SN       NVARCHAR2(100),
  INSPECT_FILE_ID  NUMBER(10),
  SN_INDEX         VARCHAR2(100 BYTE),
  SN_VALUE         NVARCHAR2(100),
  SN_FROMAT        NVARCHAR2(250),
  IS_BREAK_SN      NUMBER(10)
);

ALTER TABLE INSPECT_SN_REMAIN ADD (
  PRIMARY KEY
 (ID)
    USING INDEX );


--7 督办最新值

CREATE TABLE INSPECT_FILE_SN
(
  ID           NUMBER(10)                       NOT NULL,
  CREATE_ID    NUMBER(10),
  CREATE_TIME  DATE,
  UPDATE_ID    NUMBER(10),
  UPDATE_TIME  DATE,
  SN_INDEX     NVARCHAR2(100),
  SN_VALUE     NVARCHAR2(100),
  INSPECT_SN_ID    NUMBER(10),
  SN_FORMAT     NVARCHAR2(100),
  SN_FORMAT_VALUE     NVARCHAR2(100),
  SN_LAST      NUMBER(10)
);

ALTER TABLE INSPECT_FILE_SN ADD (
  PRIMARY KEY
 (ID)
    USING INDEX);


--8 督办信息

CREATE TABLE INSPECT_FILE
(
  ID               NUMBER(10)                   NOT NULL,
  SN               NVARCHAR2(100),
  NAME             NVARCHAR2(200)               NOT NULL,
  INSPECT_DATE     DATE,
  LINKMAN          NVARCHAR2(50),
  PHONE            NVARCHAR2(50),
  MAIN             NVARCHAR2(50),
  ASSIST           NVARCHAR2(50),
  CONTENT          NVARCHAR2(2000),
  STATUS           NUMBER(10),
  CREATE_ID        NUMBER(10),
  CREATE_TIME      DATE,
  UPDATE_ID        NUMBER(10),
  UPDATE_TIME      DATE,
  SEND_DATE        DATE,
  INSPECT_TYPE_ID  NUMBER(10)                   NOT NULL,
  PRIORITY_ID      NUMBER(10),
  INSPECT_DEPT_ID  NUMBER(10),
  AUDIT_USER_ID    NUMBER(10),
  USER_ID          NUMBER(10),
  SN_FORMAT        NVARCHAR2(100),
  OPTINION         NVARCHAR2(1000),
  OLD_STATUS       NUMBER(10)
);

ALTER TABLE INSPECT_FILE ADD (
  PRIMARY KEY
 (ID)
    USING INDEX);


ALTER TABLE INSPECT_FILE ADD (
  CONSTRAINT FKF94C78C7A7DF2192 
 FOREIGN KEY (INSPECT_DEPT_ID) 
 REFERENCES SYSTEM_DEPTS (ID));

ALTER TABLE INSPECT_FILE ADD (
  CONSTRAINT FKF94C78C7E56636FD 
 FOREIGN KEY (USER_ID) 
 REFERENCES SYSTEM_USERS (ID));

ALTER TABLE INSPECT_FILE ADD (
  CONSTRAINT FKF94C78C7E0436E99 
 FOREIGN KEY (AUDIT_USER_ID) 
 REFERENCES SYSTEM_USERS (ID));

ALTER TABLE INSPECT_FILE ADD (
  CONSTRAINT FKF94C78C77CE29820 
 FOREIGN KEY (PRIORITY_ID) 
 REFERENCES BASE_PARAM (ID));

ALTER TABLE INSPECT_FILE ADD (
  CONSTRAINT FKF94C78C711C06B51 
 FOREIGN KEY (INSPECT_TYPE_ID) 
 REFERENCES INSPECT_TYPE (ID));


--9.督办关联附件

CREATE TABLE INSPECT_FILE_ATTACH
(
  ID               NUMBER(10)                   NOT NULL,
  USER_ID          NUMBER(10),
  CREATEDATE       DATE,
  SERVERFILE       NVARCHAR2(200)               NOT NULL,
  FILENAME         NVARCHAR2(100)               NOT NULL,
  FILEEXT          NVARCHAR2(100)               NOT NULL,
  FILESIZE         NUMBER(10),
  INSPECT_FILE_ID  NUMBER(10)                   NOT NULL
);

ALTER TABLE INSPECT_FILE_ATTACH ADD (
  PRIMARY KEY
 (ID)
    USING INDEX);


ALTER TABLE INSPECT_FILE_ATTACH ADD (
  CONSTRAINT FKD3D554BD119CAC11 
 FOREIGN KEY (INSPECT_FILE_ID) 
 REFERENCES INSPECT_FILE (ID));


--10.事项信息

CREATE TABLE INSPECT_PROCEED
(
  ID                 NUMBER(10)                 NOT NULL,
  TITLE              NVARCHAR2(200)             NOT NULL,
  SN                 NVARCHAR2(50)              NOT NULL,
  ASSIST             NVARCHAR2(100),
  STATUS             NUMBER(10)                 NOT NULL,
  REMIND_COUNT       NUMBER(10),
  DECIDE_TIME        DATE,
  NEED_FINISH_TIME   DATE,
  WARN_HOUR          NUMBER(10),
  IS_REMIND          NUMBER(10),
  REMIND_DATE        DATE,
  REMIND_MON         NVARCHAR2(10),
  REMIND_DAY         NVARCHAR2(10),
  REMIND_HOUR        NVARCHAR2(10),
  REMIND_MIN         NVARCHAR2(10),
  REMIND_MODE        NUMBER(10),
  IS_CYCLE_REMIND    NUMBER(10),
  CYCLE_REMIND_MODE  NUMBER(10),
  CYCLE_SETTING      NVARCHAR2(20),
  DEFER_DATE         DATE,
  CREATE_ID          NUMBER(10),
  CREATE_TIME        DATE,
  UPDATE_ID          NUMBER(10),
  UPDATE_TIME        DATE,
  SEND_DATE          DATE,
  INSPECT_FILE_ID    NUMBER(10)                 NOT NULL,
  CYCLE_END_DATE     DATE,
  PROGRESS           NVARCHAR2(10),
  OPINION            NVARCHAR2(1000),
  OLD_STATUS         NUMBER(10),
  IS_DEFER           NUMBER(10),
  FINISH_TIME        DATE,
  DEFER_DESCN        NVARCHAR2(400)
);

ALTER TABLE INSPECT_PROCEED ADD (
  PRIMARY KEY
 (ID)
    USING INDEX );


ALTER TABLE INSPECT_PROCEED ADD (
  CONSTRAINT FK4A9FD183119CAC11 
 FOREIGN KEY (INSPECT_FILE_ID) 
 REFERENCES INSPECT_FILE (ID));


--11.督办参与人员

CREATE TABLE INSPECT_USER
(
  ID                  NUMBER(10)                NOT NULL,
  TYPE                NVARCHAR2(50),
  STATUS              NUMBER(10),
  CREATE_ID           NUMBER(10),
  CREATE_TIME         DATE,
  UPDATE_ID           NUMBER(10),
  UPDATE_TIME         DATE,
  WEIGHT              NUMBER(10),
  PROGRESS            NUMBER(10),
  INSPECT_PROCEED_ID  NUMBER(10),
  INSPECT_FILE_ID     NUMBER(10),
  USER_ID             NUMBER(10),
  NONE                NUMBER(10),
  ELT                 NUMBER(10),
  PARENT_ID           NUMBER(10),
  DEFER_COUNT         NUMBER(10),
  DEFER_INFO          NVARCHAR2(2000),
  PRESENT_ID          NUMBER(10)
);

ALTER TABLE INSPECT_USER ADD (
  PRIMARY KEY
 (ID)
    USING INDEX);


ALTER TABLE INSPECT_USER ADD (
  CONSTRAINT FKF9536F16E56636FD 
 FOREIGN KEY (USER_ID) 
 REFERENCES SYSTEM_USERS (ID));

ALTER TABLE INSPECT_USER ADD (
  CONSTRAINT FKF9536F16119CAC11 
 FOREIGN KEY (INSPECT_FILE_ID) 
 REFERENCES INSPECT_FILE (ID));

ALTER TABLE INSPECT_USER ADD (
  CONSTRAINT FKF9536F1640C3EBC3 
 FOREIGN KEY (INSPECT_PROCEED_ID) 
 REFERENCES INSPECT_PROCEED (ID));

ALTER TABLE INSPECT_USER ADD (
  CONSTRAINT FKF9536F1662EDE39D 
 FOREIGN KEY (PARENT_ID) 
 REFERENCES INSPECT_USER (ID));

ALTER TABLE INSPECT_USER ADD (
  CONSTRAINT FKF9536F16EE2CD19B 
 FOREIGN KEY (ELT) 
 REFERENCES SYSTEM_USERS (ID));

ALTER TABLE INSPECT_USER ADD (
  CONSTRAINT FKF9536F16EE5EF826 
 FOREIGN KEY (NONE) 
 REFERENCES SYSTEM_USERS (ID));

ALTER TABLE INSPECT_USER ADD (
  CONSTRAINT FKF9536F1640032DEC 
 FOREIGN KEY (PRESENT_ID) 
 REFERENCES INSPECT_USER (ID));


--12.督办审核信息

CREATE TABLE INSPECT_AUDIT_INFO
(
  ID                NUMBER(10)                  NOT NULL,
  STATUS            NVARCHAR2(50)               NOT NULL,
  CREATE_TIME       DATE                        NOT NULL,
  DESCN             NVARCHAR2(1000),
  USER_ID           NUMBER(10),
  WORKFLOW_SIGN_ID  NUMBER(10),
  INSPECT_FILE_ID   NUMBER(10),
  INSPECT_USER_ID   NUMBER(10)
);

ALTER TABLE INSPECT_AUDIT_INFO ADD (
  PRIMARY KEY
 (ID)
    USING INDEX );

ALTER TABLE INSPECT_AUDIT_INFO ADD (
  CONSTRAINT FK68BE519D3BD4D5B1 
 FOREIGN KEY (INSPECT_USER_ID) 
 REFERENCES INSPECT_USER (ID));

ALTER TABLE INSPECT_AUDIT_INFO ADD (
  CONSTRAINT FK68BE519D119CAC11 
 FOREIGN KEY (INSPECT_FILE_ID) 
 REFERENCES INSPECT_FILE (ID));

ALTER TABLE INSPECT_AUDIT_INFO ADD (
  CONSTRAINT FK68BE519DE56636FD 
 FOREIGN KEY (USER_ID) 
 REFERENCES SYSTEM_USERS (ID));

ALTER TABLE INSPECT_AUDIT_INFO ADD (
  CONSTRAINT FK68BE519DDE6A4DDD 
 FOREIGN KEY (WORKFLOW_SIGN_ID) 
 REFERENCES WORKFLOW_SIGNATURE (ID));


--13 催办信息表

CREATE TABLE INSPECT_REMIND
(
  ID                  NUMBER(10)                NOT NULL,
  REMIND_TYPE         NUMBER(10),
  STATUS              NUMBER(10),
  REMIND_COUNT        NUMBER(10),
  DESCN               NVARCHAR2(255),
  CREATE_ID           NUMBER(10),
  CREATE_TIME         DATE,
  UPDATE_ID           NUMBER(10),
  UPDATE_TIME         DATE,
  USER_ID             NUMBER(10),
  INSPECT_PROCEED_ID  NUMBER(10)
);

ALTER TABLE INSPECT_REMIND ADD (
  PRIMARY KEY
 (ID)
    USING INDEX);


ALTER TABLE INSPECT_REMIND ADD (
  CONSTRAINT FKEC53BD9040C3EBC3 
 FOREIGN KEY (INSPECT_PROCEED_ID) 
 REFERENCES INSPECT_PROCEED (ID));

ALTER TABLE INSPECT_REMIND ADD (
  CONSTRAINT FKEC53BD90E56636FD 
 FOREIGN KEY (USER_ID) 
 REFERENCES SYSTEM_USERS (ID));



 --14 催办接受人信息及状态
 
CREATE TABLE INSPECT_REMIND_USER
(
  ID                 NUMBER(10)                 NOT NULL,
  READ_STATUS        NUMBER(10),
  STATUS             NUMBER(10),
  READ_TIME          DATE,
  USER_ID            NUMBER(10),
  INSPECT_REMIND_ID  NUMBER(10)
);

ALTER TABLE INSPECT_REMIND_USER ADD (
  PRIMARY KEY
 (ID)
    USING INDEX);


ALTER TABLE INSPECT_REMIND_USER ADD (
  CONSTRAINT FK4EA5E11AE56636FD 
 FOREIGN KEY (USER_ID) 
 REFERENCES SYSTEM_USERS (ID));

ALTER TABLE INSPECT_REMIND_USER ADD (
  CONSTRAINT FK4EA5E11AC19F79B1 
 FOREIGN KEY (INSPECT_REMIND_ID) 
 REFERENCES INSPECT_REMIND (ID));


--15事项办理信息

CREATE TABLE INSPECT_PROCEED_INFO
(
  ID                  NUMBER(10)                NOT NULL,
  TYPE                NVARCHAR2(10),
  DEFER_DATE          DATE,
  CREATE_ID           NUMBER(10),
  CREATE_TIME         DATE,
  UPDATE_ID           NUMBER(10),
  UPDATE_TIME         DATE,
  DESCN               NVARCHAR2(2000),
  WORKFLOW_SIGN_ID    NUMBER(10),
  INSPECT_PROCEED_ID  NUMBER(10),
  USER_ID             NUMBER(10),
  PROGRESS            NUMBER(10),
  INSPECT_USER_ID     NUMBER(10)
);


ALTER TABLE INSPECT_PROCEED_INFO ADD (
  PRIMARY KEY
 (ID)
    USING INDEX );


ALTER TABLE INSPECT_PROCEED_INFO ADD (
  CONSTRAINT FKA91C5EA40C3EBC3 
 FOREIGN KEY (INSPECT_PROCEED_ID) 
 REFERENCES INSPECT_PROCEED (ID));

ALTER TABLE INSPECT_PROCEED_INFO ADD (
  CONSTRAINT FKA91C5EADE6A4DDD 
 FOREIGN KEY (WORKFLOW_SIGN_ID) 
 REFERENCES WORKFLOW_SIGNATURE (ID));

ALTER TABLE INSPECT_PROCEED_INFO ADD (
  CONSTRAINT FKA91C5EAE56636FD 
 FOREIGN KEY (USER_ID) 
 REFERENCES SYSTEM_USERS (ID));

ALTER TABLE INSPECT_PROCEED_INFO ADD (
  CONSTRAINT FKA91C5EA3BD4D5B1 
 FOREIGN KEY (INSPECT_USER_ID) 
 REFERENCES INSPECT_USER (ID));


--16 事项附件及办理过程中上传的附件

CREATE TABLE INSPECT_PROCEED_ATTACH
(
  ID                       NUMBER(10)           NOT NULL,
  USER_ID                  NUMBER(10),
  CREATEDATE               DATE,
  SERVERFILE               NVARCHAR2(200)       NOT NULL,
  FILENAME                 NVARCHAR2(100)       NOT NULL,
  FILEEXT                  NVARCHAR2(100)       NOT NULL,
  FILESIZE                 NUMBER(10),
  INSPECT_PROCEED_ID       NUMBER(10)           NOT NULL,
  INSPECT_PROCEED_INFO_ID  NUMBER(10)           NOT NULL
);

ALTER TABLE INSPECT_PROCEED_ATTACH ADD (
  PRIMARY KEY
 (ID)
    USING INDEX);


ALTER TABLE INSPECT_PROCEED_ATTACH ADD (
  CONSTRAINT FK9FEBF0816F020CCA 
 FOREIGN KEY (INSPECT_PROCEED_INFO_ID) 
 REFERENCES INSPECT_PROCEED_INFO (ID));

ALTER TABLE INSPECT_PROCEED_ATTACH ADD (
  CONSTRAINT FK9FEBF08140C3EBC3 
 FOREIGN KEY (INSPECT_PROCEED_ID) 
 REFERENCES INSPECT_PROCEED (ID));


--17 事项中操作日志

CREATE TABLE INSPECT_LOG
(
  ID                  NUMBER(10)                NOT NULL,
  LOG_TYPE            NVARCHAR2(50),
  DESCN               NVARCHAR2(2000),
  CREATE_ID           NUMBER(10),
  CREATE_TIME         DATE,
  UPDATE_ID           NUMBER(10),
  UPDATE_TIME         DATE,
  OPER_USER_ID        NUMBER(10),
  INSPECT_PROCEED_ID  NUMBER(10),
  INSPECT_FILE_ID     NUMBER(10),
  INSPECT_PROCEED     NUMBER(10),
  INSPECT_FILE        NUMBER(10),
  OPER_USER           NUMBER(10)
);

ALTER TABLE INSPECT_LOG ADD (
  PRIMARY KEY
 (ID)
    USING INDEX);

ALTER TABLE INSPECT_LOG ADD (
  CONSTRAINT FKA4F20A99119CAC11 
 FOREIGN KEY (INSPECT_FILE_ID) 
 REFERENCES INSPECT_FILE (ID));

ALTER TABLE INSPECT_LOG ADD (
  CONSTRAINT FKA4F20A9940C3EBC3 
 FOREIGN KEY (INSPECT_PROCEED_ID) 
 REFERENCES INSPECT_PROCEED (ID));

ALTER TABLE INSPECT_LOG ADD (
  CONSTRAINT FKA4F20A99537DD60C 
 FOREIGN KEY (OPER_USER_ID) 
 REFERENCES SYSTEM_USERS (ID));

ALTER TABLE INSPECT_LOG ADD (
  CONSTRAINT FKA4F20A996F242FEF 
 FOREIGN KEY (INSPECT_PROCEED) 
 REFERENCES INSPECT_PROCEED (ID));

ALTER TABLE INSPECT_LOG ADD (
  CONSTRAINT FKA4F20A99E0CCB545 
 FOREIGN KEY (INSPECT_FILE) 
 REFERENCES INSPECT_FILE (ID));

ALTER TABLE INSPECT_LOG ADD (
  CONSTRAINT FKA4F20A99512A880A 
 FOREIGN KEY (OPER_USER) 
 REFERENCES SYSTEM_USERS (ID));
 
 
 --
create sequence BASE_PARAM_ID_SEQ
minvalue 1
maxvalue 999999999999999999999999999
start with 1
increment by 1
cache 20;
 --
create sequence INSPECT_AUDIT_INFO_ID_SEQ
minvalue 1
maxvalue 999999999999999999999999999
start with 1
increment by 1
cache 20;
--
create sequence INSPECT_FILE_ID_SEQ
minvalue 1
maxvalue 999999999999999999999999999
start with 1
increment by 1
cache 20;
-- 
create sequence INSPECT_FILE_ATTACH_ID_SEQ
minvalue 1
maxvalue 999999999999999999999999999
start with 1
increment by 1
cache 20;

-- 
create sequence INSPECT_FILE_SN_ID_SEQ
minvalue 1
maxvalue 999999999999999999999999999
start with 1
increment by 1
cache 20;

--

create sequence INSPECT_LOG_ID_SEQ
minvalue 1
maxvalue 999999999999999999999999999
start with 1
increment by 1
cache 20;

-- 
create sequence INSPECT_OBSERVER_ID_SEQ
minvalue 1
maxvalue 999999999999999999999999999
start with 1
increment by 1
cache 20;

-- 
create sequence INSPECT_OBSERVER_DEPT_ID_SEQ
minvalue 1
maxvalue 999999999999999999999999999
start with 1
increment by 1
cache 20;


create sequence INSPECT_PROCEED_ID_SEQ
minvalue 1
maxvalue 999999999999999999999999999
start with 1
increment by 1
cache 20;

create sequence INSPECT_PROCEED_ATTACH_ID_SEQ
minvalue 1
maxvalue 999999999999999999999999999
start with 1
increment by 1
cache 20;


create sequence INSPECT_PROCEED_INFO_ID_SEQ
minvalue 1
maxvalue 999999999999999999999999999
start with 1
increment by 1
cache 20;

create sequence INSPECT_REMIND_ID_SEQ
minvalue 1
maxvalue 999999999999999999999999999
start with 1
increment by 1
cache 20;


create sequence INSPECT_REMIND_USER_ID_SEQ
minvalue 1
maxvalue 999999999999999999999999999
start with 1
increment by 1
cache 20;

create sequence INSPECT_SN_REMAIN_ID_SEQ
minvalue 1
maxvalue 999999999999999999999999999
start with 1
increment by 1
cache 20;


create sequence INSPECT_SN_SET_ID_SEQ
minvalue 1
maxvalue 999999999999999999999999999
start with 1
increment by 1
cache 20;

create sequence INSPECT_TYPE_ID_SEQ
minvalue 1
maxvalue 999999999999999999999999999
start with 1
increment by 1
cache 20;

create sequence INSPECT_USER_ID_SEQ
minvalue 1
maxvalue 999999999999999999999999999
start with 1
increment by 1
cache 20;









